
RIGHT


JOIN allows for the three tables to be combined

JOINEDIT I created but it is the same as editmovies

AND 

JOIN DELETE ALLOWS FOR INFO TO BE DELETED FROM THE JOIN STUFF 




** Lauren's words - this is the code from the join.php with tables and a delete button **

<table border="1">
<tr>

<td>Title</td>
<td>Description</td>
<td>Running Time</td>
<td>Age Rating</td>
<td>Trailer</td>
<td>Purchase Tickets</td>
</tr>

<?
while($r=mysqli_fetch_array($result))  
{?>
<tr>
	

<td><?echo $r["title"];?></td>
<td><?echo $r["description"];?></td>
<td><?echo $r["runningtime"];?></td>
<td><?echo $r["rating"];?></td>
<td><?echo $r["trailer"];?></td>
<td><?echo $r["purchasetickets"];?></td>

</tr>

	<form action="delete.php" method="post">
	<input type="hidden" value="<?echo $r["movieid"];?>" name="theid">
	<input type="Submit" value="Delete">
	</form>
	
<?
}
?>
</table>


** Lauren's words - this is the code from the join.php without tables and a delete button **

<?
while($r=mysqli_fetch_array($result))  
{?><?

	

echo $r["title"].' ';
echo $r["description"].' ';
echo $r["runningtime"].' ';
echo $r["rating"].' ';
echo $r["trailer"].' ';
echo $r["purchasetickets"];?>


	<form action="delete.php" method="post">
	<input type="hidden" value="<?echo $r["movieid"];?>" name="theid">
	<input type="Submit" value="Delete">
	</form>
	
<?
}
?>


